Spread for ASP.NET 12 Product Documentation
SetConditionalFormatting(Int32,Int32,Int32,Int32,Boolean,IConditionalFormattingRule[]) Method


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class > SetConditionalFormatting Method : SetConditionalFormatting(Int32,Int32,Int32,Int32,Boolean,IConditionalFormattingRule[]) Method
Starting row index
Starting column index
Number of rows
Number of columns
Rule(s) can be merged into an existing conditional format if they affect the same cell range(s).
The specified rules to apply for a specified range of cells
Sets conditional formatting for a specified range of cells on the sheet based on specified rules.
Syntax
'Declaration
 
Public Overloads Sub SetConditionalFormatting( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer, _
   ByVal combinable As Boolean, _
   ByVal ParamArray rules() As IConditionalFormattingRule _
) 
'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim combinable As Boolean
Dim rules() As IConditionalFormattingRule
 
instance.SetConditionalFormatting(row, column, rowCount, columnCount, combinable, rules)
public void SetConditionalFormatting( 
   int row,
   int column,
   int rowCount,
   int columnCount,
   bool combinable,
   params IConditionalFormattingRule[] rules
)

Parameters

row
Starting row index
column
Starting column index
rowCount
Number of rows
columnCount
Number of columns
combinable
Rule(s) can be merged into an existing conditional format if they affect the same cell range(s).
rules
The specified rules to apply for a specified range of cells
See Also

Reference

SheetView Class
SheetView Members
Overload List